*******************************************************************************
****						Appendix Table G.1	- ENTRY-EXIT FREQUENCY MATRIX
*******************************************************************************


use .\data\clean\I10W_laneuse_dataset_15nov14_wcensus, clear
drop if holiday==1
drop if dow==0 | dow==6
*WTP calculation
gen TT_dif_hr=dist/MLspeed-dist/ELspeed
gen WTP2=charged_toll/TT_dif_hr
drop if ELspeed==.
drop if TT_dif_hr==.
la var TT_dif_hr "Time in Hours"
drop if dow==0|dow==6
keep if acct_type=="PRIVATE"&occupancy~="HOV-3"
keep if hour>4 & hour<9
drop if TT_dif_hr<0
tab entry_plaza exit_plaza, matcell(freq)
putexcel set ".\results\appendix\AppendixFigsTabs.xlsx", modify sheet("Appendix Table G.1")
putexcel B2=matrix(freq) 
putexcel A2=("WT01") A3=("WT02") A4=("WT03") A5=("WT05") B1=("WT03") C1=("WT04") D1=("WT05") E1=("WT06")
